Functional Dependencies of Data Tables Over Domains with Similarity Relations
نویسندگان
چکیده
We study attribute dependencies in a setting of fuzzy logic. Our dependencies are described by formulas A ⇒ B where A and B are fuzzy sets of attributes. The meaning of A ⇒ B is that any two objects that have similar values on attributes from A have also similar values on attributes from B. Our approach generalizes classical functional dependencies from databases and also several approaches to functional dependencies in fuzzy databases. We show a connection to other interpretation of formulas A ⇒ B which we studied before. Although the two interpretations are different, they have the same concept of semantic entailment. This connection enables us to find a complete axiomatization of reasoning with our attribute dependencies. We prove completeness theorem in the usual as well as in a so-called graded style. The connection also enables us to compute a complete non-redundant basis of all functional dependencies which are true in a data table. We present examples and and outline future research.
منابع مشابه
Data Tables with Similarity Relations: Functional Dependencies, Complete Rules and Non-redundant Bases
We study rules A ⇒ B describing attribute dependencies in tables over domains with similarity relations. A ⇒ B reads “for any two table rows: similar values of attributes from A imply similar values of attributes from B”. The rules generalize ordinary functional dependencies in that they allow for processing of similarity of attribute values. Similarity is modeled by reflexive and symmetric fuz...
متن کاملAn Efficient Algorithm for Reasoning about Fuzzy Functional Dependencies
A sound and complete Automated Prover for the Fuzzy Simplification Logic (FSL logic) is introduced and based on it a method for efficiently reasoning about fuzzy functional dependencies over domains with similarity relations. The complexity of the algorithm is the same as that of equivalent algorithms for crisp functional dependencies that appear in the literature.
متن کاملA complete logic for fuzzy functional dependencies over t-norms
A fuzzification of the concept of functional dependency based on t-norms is presented. T-norms are equally used in the definition of the similarity relations in the domains and in the fuzziness degree assigned to functional dependencies. A sound and complete logic for this fuzzy functional dependencies is also introduced and, finally, its applicability to redundancy removing is shown.
متن کاملPavelka-style Fuzzy Logic for Attribute Implications
We present Pavelka-style fuzzy logic for reasoning about attribute implications, i.e. formulas A ⇒ B known also as association rules and functional dependencies. Fuzzy attribute implications allow for two different interpretations, namely, in data tables with graded (fuzzy) attributes and in data tables over domains with similarity relations. In the first interpretation, A ⇒ B reads “each objec...
متن کاملDesign by Example for SQL Tables with Functional Dependencies
An Armstrong relation satisfies the functional dependencies (FD) implied by a given FD set and violates all other FDs. Therefore, they form an instance of the design-by-example methodology: the example relation exhibits precisely those FDs that the current design perceives as meaningful for the application domain. The existing framework of Armstrong relations only applies to total relations. We...
متن کامل